﻿/*
#**************************************************************************
#  openSIS is a student information system for public and non-public 
#  schools from Open Solutions for Education, Inc. web: www.os4ed.com
#
#  openSIS is  web-based, open source, and comes packed with features that 
#  include student demographic info, scheduling, grade book, attendance, 
#  report cards, eligibility, transcripts, parent portal, 
#  student portal and more.   
#
#  Visit the openSIS web site at http://www.opensis.com to learn more.
#  If you have question regarding this system or the license, please send 
#  an email to info@os4ed.com.
#
#  This program is released under the terms of the GNU General Public License  
#  as  published by the Free Software Foundation, version 2 of the License. 
#  See license.txt.
#
#  This program is distributed in the hope that it will be useful,
#  but WITHOUT ANY WARRANTY; without even the implied warranty of
#  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
#  GNU General Public License for more details.
#
#  You should have received a copy of the GNU General Public License
#  along with this program.  If not, see <http://www.gnu.org/licenses/>.
#
#**************************************************************************** 

*/

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MySql.Data.MySqlClient;
using System.Data;
using System.Data.OleDb;

namespace OSISDragNDropLayer
{
   public class DragNDrop
    {

        public int SaveOrder(string fieldid, string schoolid, string sortorder, string def_cus, string catid)
        {

            DataTable dt = new DataTable();


            string connect = System.Configuration.ConfigurationManager.AppSettings["sqlConn"];
            string server = System.Configuration.ConfigurationManager.AppSettings["appserver"];


            int result = 0;

            if (server == "MSSQLServer")
            {

                using (OleDbConnection conn = new OleDbConnection(connect))
                {
                    string query = "SELECT * FROM Student_Setup_FormLayout_Order WHERE Sch_Id = '" + schoolid + "' and Field_Id ='" + fieldid + "' and FL_FieldType='" + def_cus + "'";

                    OleDbDataAdapter da = new OleDbDataAdapter(query, conn);
                    da.Fill(dt);

                    if (dt.Rows.Count == 0)
                    {
                        string insquery = "insert into Student_Setup_FormLayout_Order(Field_Id,Sch_Id,FL_FieldType,Sort_Order,Cat_Id) values('" + fieldid + "','" + schoolid + "','" + def_cus + "','" + sortorder + "','" + catid + "')";

                        System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand();
                        conn.Open();
                        cmd.Connection = conn;
                        cmd.CommandText = insquery;
                        result = (int)cmd.ExecuteNonQuery();
                    }
                    else
                    {
                        string updtquery = "UPDATE Student_Setup_FormLayout_Order SET Sort_Order='" + sortorder + "' WHERE Sch_Id = '" + schoolid + "' AND Field_Id = '" + fieldid + "' AND FL_FieldType='" + def_cus + "' and Cat_Id='" + catid + "'";

                        System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand();
                        conn.Open();
                        cmd.Connection = conn;
                        cmd.CommandText = updtquery;
                        result = (int)cmd.ExecuteNonQuery();
                    }

                }
                //return result;
            }
            if (server == "MySQL")
            {

                using (MySqlConnection conn = new MySqlConnection(connect))
                {
                    string query = "SELECT * FROM Student_Setup_FormLayout_Order WHERE Sch_Id = '" + schoolid + "' and Field_Id ='" + fieldid + "' and FL_FieldType='" + def_cus + "'";

                    MySqlDataAdapter da = new MySqlDataAdapter(query, conn);
                    da.Fill(dt);

                    if (dt.Rows.Count == 0)
                    {
                        string insquery = "insert into Student_Setup_FormLayout_Order(Field_Id,Sch_Id,FL_FieldType,Sort_Order,Cat_Id) values('" + fieldid + "','" + schoolid + "','" + def_cus + "','" + sortorder + "','" + catid + "')";

                        MySqlCommand cmd = new MySqlCommand();
                        conn.Open();
                        cmd.Connection = conn;
                        cmd.CommandText = insquery;
                        result = (int)cmd.ExecuteNonQuery();
                    }
                    else
                    {
                        string updtquery = "UPDATE Student_Setup_FormLayout_Order SET Sort_Order='" + sortorder + "' WHERE Sch_Id = '" + schoolid + "' AND Field_Id = '" + fieldid + "' AND FL_FieldType='" + def_cus + "' and Cat_Id='" + catid + "'";

                        MySqlCommand cmd = new MySqlCommand();
                        conn.Open();
                        cmd.Connection = conn;
                        cmd.CommandText = updtquery;
                        result = (int)cmd.ExecuteNonQuery();
                    }

                }
                //return result;


            }
            return result;
        }



        public int SaveOrderview(string fieldid, string schoolid, string sortorder, string def_cus, string catid)
        {

            DataTable dt = new DataTable();


            string connect = System.Configuration.ConfigurationManager.AppSettings["sqlConn"];
            string server = System.Configuration.ConfigurationManager.AppSettings["appserver"];


            int result = 0;

            if (server == "MSSQLServer")
            {

                using (OleDbConnection conn = new OleDbConnection(connect))
                {
                    string query = "SELECT * FROM Student_Setup_ViewFormLayout_Order WHERE Sch_Id = '" + schoolid + "' and Field_Id ='" + fieldid + "' and FL_FieldType='" + def_cus + "'";

                    OleDbDataAdapter da = new OleDbDataAdapter(query, conn);
                    da.Fill(dt);

                    if (dt.Rows.Count == 0)
                    {
                        string insquery = "insert into Student_Setup_ViewFormLayout_Order(Field_Id,Sch_Id,FL_FieldType,Sort_Order,Cat_Id) values('" + fieldid + "','" + schoolid + "','" + def_cus + "','" + sortorder + "','" + catid + "')";

                        System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand();
                        conn.Open();
                        cmd.Connection = conn;
                        cmd.CommandText = insquery;
                        result = (int)cmd.ExecuteNonQuery();
                    }
                    else
                    {
                        string updtquery = "UPDATE Student_Setup_ViewFormLayout_Order SET Sort_Order='" + sortorder + "' WHERE Sch_Id = '" + schoolid + "' AND Field_Id = '" + fieldid + "' AND FL_FieldType='" + def_cus + "' and Cat_Id='" + catid + "'";

                        System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand();
                        conn.Open();
                        cmd.Connection = conn;
                        cmd.CommandText = updtquery;
                        result = (int)cmd.ExecuteNonQuery();
                    }

                }
                //return result;
            }
            if (server == "MySQL")
            {

                using (MySqlConnection conn = new MySqlConnection(connect))
                {
                    string query = "SELECT * FROM Student_Setup_ViewFormLayout_Order WHERE Sch_Id = '" + schoolid + "' and Field_Id ='" + fieldid + "' and FL_FieldType='" + def_cus + "'";

                    MySqlDataAdapter da = new MySqlDataAdapter(query, conn);
                    da.Fill(dt);

                    if (dt.Rows.Count == 0)
                    {
                        string insquery = "insert into Student_Setup_ViewFormLayout_Order(Field_Id,Sch_Id,FL_FieldType,Sort_Order,Cat_Id) values('" + fieldid + "','" + schoolid + "','" + def_cus + "','" + sortorder + "','" + catid + "')";

                        MySqlCommand cmd = new MySqlCommand();
                        conn.Open();
                        cmd.Connection = conn;
                        cmd.CommandText = insquery;
                        result = (int)cmd.ExecuteNonQuery();
                    }
                    else
                    {
                        string updtquery = "UPDATE Student_Setup_ViewFormLayout_Order SET Sort_Order='" + sortorder + "' WHERE Sch_Id = '" + schoolid + "' AND Field_Id = '" + fieldid + "' AND FL_FieldType='" + def_cus + "' and Cat_Id='" + catid + "'";

                        MySqlCommand cmd = new MySqlCommand();
                        conn.Open();
                        cmd.Connection = conn;
                        cmd.CommandText = updtquery;
                        result = (int)cmd.ExecuteNonQuery();
                    }

                }
                //return result;


            }
            return result;
        }

    }
}
